Installing iFilters

FTR with SQL Server requires that you install iFilters for the file types you want to index. For example, to index PDFs you must install the Adobe PDF iFilter; to index DGNs you must install the Bentley DGN iFilter.

The iFilters must be installed on the SQL Server computer where your FTR database is located.

Bentley DGN iFilter

To index DGN files, install the Bentley DGN iFilter.

The Bentley DGN iFilter is automatically installed when you install the Bentley DGN Reader, which you can download from Bentley's Software Fulfillment Center .

Download one of the following:

Bentley DGN Reader for Windows 7 (x86) 08.11.08.06.msi
Bentley DGN Reader for Windows 7 (x64) 08.11.08.06.msi

Microsoft Office iFilters

To index Microsoft Office documents, download and install the latest Microsoft Office iFilters:

Microsoft Filter Pack 2.0:
Microsoft Filter Pack 2.0 Service Pack 1:
Microsoft Filter Pack 2.0 Service Pack 2:

Windows TIFF iFilter

To index TIFF files, the Windows TIFF iFilter is required. Make sure you turn off the TIFF iFIlter's performance optimization by following the steps in the procedure, "Forcing optical character recognition of every page of a TIFF image document" found in the Microsoft online documentation link below:

https://technet.microsoft.com/en-us/library/dd744701.aspx

Adobe PDF iFilters

To index PDFs, download and install Adobe PDF iFilter v9:

ftp://ftp.adobe.com/pub/adobe/acrobat/win/9.x/PDFiFilter64installer.zip

As recommended by Adobe, after installing the Adobe iFilter, add (append) the full path to the iFilter's "bin" folder to the end of the system Path environment variable. For example:

;C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin

DWG iFilters

By default, AssetWise is configured to use ProjectWise InterPlot Server instead of a DWG iFilter to index DWG files. Rather than directly indexing the DWG file, AssetWise uses ProjectWise InterPlot Server to create a PDF rendition of the DWG file to be indexed. Once the PDF exists, AssetWise indexes the PDF instead of the DWG file.

However, if you have a DWG iFilter you would like to try using instead of ProjectWise InterPlot Server, install the DWG iFilter and then run this command against the database:

update m3_supported_ftr_formats set engine_id = ( SELECT engine_id FROM m3_engines WHERE engine_name = 'FTR') where format_id in ( select format_id 
  FROM m3_formats where file_ext like '%DWG%')

Update SQL Server After Installing iFilters

After installing any of the iFilters above you must run the following commands in SQL Server Management Studio:

exec sp_fulltext_service @action='load_os_resources', @value=1; -- update os resources
go
exec sp_fulltext_service 'verify_signature', 0 -- don't verify signatures
go
exec sp_fulltext_service 'update_languages'; -- update language list
go
exec sp_fulltext_service 'restart_all_fdhosts'; -- restart daemon
go
reconfigure with override
go

You can refer to this MSDN documentation for more details.

Note: To view the list of currently configured iFilters run the stored procedure:

sp_help_fulltext_system_components 'all'